System Tables

System tables are used by all the companies you have created in Traverse. While most tables exist once for each company you create in Traverse, system tables hold the data for all companies in a single installation of Traverse. For example, each company has its own inventory tables, but all companies share the same budget forecasting tables.

Column Name Column Type Length Default Value Description Enumeration
TableID nvarchar 5      
TableDescription pDescription 255      
ColumnType tinyint 1 0   0 = Recovery Period, 1 = Month Placed in Service, 2 = Year Placed in Service
UseMaxValues bit 1      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
TableID nvarchar 5      
Column pDec 13 0    
DYear tinyint 1      
Percentage pDec 13 0    
MaxValue pDec 13 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BFCompRef int 4      
BFRef int 4      
CompId pCompID 3      
BFType tinyint 1 0 Budget/Forecast Type 0 = Budget, 1 = Forecast
Status smallint 2 0 Status 0 = Invalid, 1 = Valid
DefaultYn bit 1 0    
PdFrom smallint 2      
YrFrom smallint 2      
PdThru smallint 2      
YrThru smallint 2      
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BFCompRef int 4      
AcctId pGlAcct 40      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BFRef int 4      
BFType tinyint 1 0 Budget/Forecast Type 0 = Budget, 1 = Forecast
Descr varchar 30      
Heading varchar 10      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ContentId varchar 10      
LineNum int 4      
ClassId tinyint 1      
BegAcctTypeId smallint 2      
EndAcctTypeId smallint 2      
Desc varchar 30      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ContentId varchar 10      
Desc varchar 25      
Template bit 1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SrcCode varchar 2      
SrcDesc varchar 30      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
StmtId varchar 10      
StmtName varchar 30      
RowId varchar 10      
ColumnId varchar 10      
StmtHdg1 varchar 50      
StmtHdg2 varchar 50      
StmtHdg3 varchar 50      
StmtHdg4 varchar 50      
StmtFooter1 varchar 50      
StmtFooter2 varchar 50      
StmtFooter3 varchar 50      
StmtFooter4 varchar 50      
BlankLinesHdr tinyint 1      
BlankLinesFtr tinyint 1      
AllowShift smallint 2      
FooterStartLine smallint 2      
PaperSize smallint 2   Paper Size 1 = 8.5 x 11 in, 2 = 8.5 x 14 in, 3 = 8.5 x 22 in, 4 = A-4, 5 = 11 x 17 in
PaperOrientation smallint 2   Paper Orientation 1 = Portrait, 2 = Landscape
PrintPageNo smallint 2      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BatchID varchar 10      
BatchDesc varchar 50      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
BatchId varchar 10      
BatchSeqNo smallint 2      
StmtId varchar 10      
Pd smallint 2      
PrintSegDtl smallint 2      
PrintZeroBal smallint 2      
PrintWSDateTime smallint 2      
CompanyList varchar max      
SegSort varchar max      
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ColumnId varchar 10      
Name varchar 50      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
ColumnId varchar 10      
SeqNo varchar 2      
Name varchar 50      
Source varchar 50   Column Source (Formula1) = Formula 1, (Formula2) = Formula 2, (Formula3) = Formula 3, AcctId = Account ID, AcctType = Account Type, Actual = Actual, Budget = Budget, Desc = Description, Forecast = Forecast, LYActual = Last Year Actual
HowFarBack smallint 2      
AsOfWhen tinyint 1   GL Activity As Of 1 = Current Period, 2 = Previous Period, 3 = Previous Quarter, 4 = Period Relative to Current, 5 = YTD Relative to Current, 6 = Year-End Balance, 7 = Year Relative to Current, 8 = YTD Year Relative to Current
Formula varchar 50      
SortOrder tinyint 1      
Width real 4 0    
Mask varchar 50      
Font tinyint 1      
DR/CRsign tinyint 1      
ColHdg1 varchar 50      
ColHdg2 varchar 50      
ColHdg3 varchar 50      
PrintCol smallint 2 (-1) Print Column Flag 0 = No, -1 = Yes
AllowTotal smallint 2      
AddnSpacing smallint 2 0    
Scaling tinyint 1 -1 Scaling 1 = (no scaling), 2 = by 100, 3 = by 1000
CompanyId pCompID 3      
ColHdg1Ext varchar 2      
ColHdg2Ext varchar 2      
ColHdg3Ext varchar 2      
ColHdg1Align tinyint 1 0 Column Heading Alignment 0 = None, 1 = Left, 2 = Center, 3 = Right
ColHdg2Align tinyint 1 0 Column Heading Alignment 0 = None, 1 = Left, 2 = Center, 3 = Right
ColHdg3Align tinyint 1 0 Column Heading Alignment 0 = None, 1 = Left, 2 = Center, 3 = Right
ColHdg1Prop tinyint 1 0 Column Heading Attributes 0 = None, 1 = Bold, 2 = Underline, 3 = Bold & Underline, 4 = Italic, 5 = Bold & Italic, 6 = Italic & Underline, 7 = Bold, Italic, & Underline
ColHdg2Prop tinyint 1 0 Column Heading Attributes 0 = None, 1 = Bold, 2 = Underline, 3 = Bold & Underline, 4 = Italic, 5 = Bold & Italic, 6 = Italic & Underline, 7 = Bold, Italic, & Underline
ColHdg3Prop tinyint 1 0 Column Heading Attributes 0 = None, 1 = Bold, 2 = Underline, 3 = Bold & Underline, 4 = Italic, 5 = Bold & Italic, 6 = Italic & Underline, 7 = Bold, Italic, & Underline
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RowId varchar 10      
Name varchar 50      
CompanyId pCompID 3      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
RowId varchar 10      
SeqNo smallint 2      
Name varchar 50      
Type varchar 2   Row Type AD = Account Detail, AS = Account Summary, BB = Beg Balance of Year, BD = Beg Balance Detail, BS = Beg Balance Summary, CL = Shift Columns Left, CR = Shift Columns Right, ED = End Balance Detail, ES = End Balance Summary, HC = Center Heading, HP = Print Heading, T1 = Total 1, T2 = Total 2, T3 = Total 3, T4 = Total 4, T5 = Total 5, T6 = Total 6, T7 = Total 7, T8 = Total 8, T9 = Total 9, UD = Double Underscore, US = Single Underscore
RowText varchar 50      
PrintTotals smallint 2      
SkipLinesAfter smallint 2      
PageBreak smallint 2      
Total1 varchar 1      
Total2 varchar 1      
Total3 varchar 1      
Total4 varchar 1      
Total5 varchar 1      
Total6 varchar 1      
Total7 varchar 1      
Total8 varchar 1      
Total9 varchar 1      
PrintDRCR smallint 2   Print Debits, Credits, or Both 1 = Debit, 2 = Both, -1 = Credit
DescTab smallint 2      
ReverseSign smallint 2      
PrintRow smallint 2      
CompanyId pCompID 3      
DollarSign smallint 2      
CharsShift smallint 2      
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
SourceId tinyint 1      
TransType tinyint 1      
TypeDescr nvarchar 100      
AppId nchar 20      
RptCat tinyint 1 -1    
Column Name Column Type Length Default Value Description Enumeration
AppID nvarchar 2      
Description varchar 50      
Version varchar 50      
BaseAppID nvarchar 2      
DefaultTable varchar 50      
ClientProgYn bit 1 -1    
Column Name Column Type Length Default Value Description Enumeration
CompId pCompID 3      
Name varchar 30      
Addr1 varchar 30      
Addr2 varchar 30      
Country varchar 6      
City varchar 30      
Region varchar 10      
PostalCode varchar 10      
Phone varchar 20      
Fax varchar 20      
SiteNum varchar 20      
CostingMethod smallint 2 0    
LangDflt varchar 50 'eng'    
LangAdmin varchar 50 'eng'    
BaseCurrency pCurrency 6      
UserLogUpdate bit 1 -1    
AuditLog bit 1 -1    
Security bit 1 0    
UseLogo bit 1 0    
GlAcctMask varchar 50      
CustIdMask varchar 50      
VendIDMask varchar 50      
ItemIdMask varchar 50      
EmployeeIdMask varchar 50      
ColorSetId varchar 15 'standard'    
TinFed varchar 15      
TinState varchar 15      
Logo image 16      
Email text 16      
Internet text 16      
MaxRecords int 4 0    
ProtectInfo nvarchar 510      
WorkWeekMask int 4 -62 Work Week Mask 1 = Sunday, 2 = Monday, 4 = Tuesday, 8 = Wednesday, 16 = Thursday, 32 = Friday, 64 = Saturday (bitmasked)
FirstDayOfTheWeek tinyint 1 -1 First Day of Week 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday
CompressWeekendDays bit 1 -1    
ShowTimeAsClocks bit 1 0    
ShowEndTime bit 1 0    
TimeScale smallint 2 -30 Time Scale 5 = 5 Minutes, 6 = 6 Minutes, 10 = 10 Minutes, 15 = 15 Minutes, 30 = 30 Minutes, 60 = 60 Minutes
WorkDayStartTime varchar 8 '08:00 am'    
WorkDayEndTime varchar 8 '05:00 pm'    
WeeksCount tinyint 1 -6    
DftlView tinyint 1 -3    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ConfigRef int 4      
RecType smallint 2 0 Record Type 0 = Text, 1 = GL Account, 2 = Currency ID, 5 = Language ID, 6 = Base Currency GL Account, 7 = Fixed Length Numeric Text, 61 = File Name, 62 = File Path, 63 = Password, 256 = Number, 257 = Unit Cost, 258 = Unit Price, 259 = Qty, 260 = Rate, 261 = Hour, 262 = Currency, 263 = History Period, 264 = GL Period, 266 = DRP Quantities Precision, 267 = Qty Precision, 268 = Unit Cost Precision, 269 = Unit Price Precision, 270 = Hour Precision, 271 = Rate Precision, 272 = Percentage, 273 = Tinyint, 274 = Smallint, 275 = Int, 512 = Date, 513 = Time, 1024 = Boolean, 1025 = Image, 1026 = Font Color, 1027 = Font Attribute, 1029 = Multicurrency Readonly/True, 1030 = Multicurrency Visible, 2048 = Group, 2049 = App Root, 2050 = Group Root, 2051 = Role Root, 2052 = Group By GL Accounts
AppId varchar 10      
ConfigId varchar 50      
CTConfigRef int 4 0    
OptConfigRef int 4 0    
DispSeq smallint 2 0    
Visible bit 1 -1    
RoleConfigYn bit 1 0    
CaptionId varchar 50      
SrchID varchar 50      
DefaultValue varchar 255      
MaxWidth int 4 0    
RequiredYn bit 1 -1    
ValueListId varchar 50      
ReqAppId varchar 10      
ReadOnlyYn bit 1 0    
MinValue pDec 13      
MaxValue pDec 13      
Column Name Column Type Length Default Value Description Enumeration
ConfigRef int 4      
DepConfigRef int 4      
DepType tinyint 1   Dependency Type 0 = Cascade None, 1 = Cascade Yes, 2 = Cascade No, 3 = Cascade All
Note varchar 1000      
Column Name Column Type Length Default Value Description Enumeration
Country pCountry 6      
Name varchar 50      
IntlPrefixMask varchar 50      
PhoneMask varchar 50      
PostalCodeMask varchar 50      
IntlPrefix varchar 6      
UsePostNet bit 1 0    
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
CurrId pCurrency 6      
CurrDesc nvarchar 100      
CurrMask nvarchar 100      
CurrMaskSymbol varchar 50      
CurrActAvg tinyint 1 0    
CurrGlAcct pGlAcct 40      
CurrSymbol nvarchar 6      
CurrSymbolPlace tinyint 1 -1    
CurrDecPlaces tinyint 1 0    
CurrDecChar nchar 2      
CurrThousChar nchar 2      
CurrExample nvarchar 40      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Counter int 4      
CurrencyFrom pCurrency 6      
CurrencyTo pCurrency 6      
ExchRate pDec 13 0    
EffectDate datetime 8 getdate()    
Notes varchar 50      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BlockingFactor int 4   Blocking Factor 0 = No Blocking, X = pad records to a given multiple of the blocking factor
DefaultFileName varchar 255      
Description varchar 30      
ExecuteCommand varchar 255      
FieldSeparator varchar 255      
FileType tinyint 1   Export File Type 0 = Block, 1 = Delimited, 2 = Fixed Width, 3 = XML
FunctionId varchar 10      
LayoutId varchar 10      
LayoutRef int 4      
Provider varchar max      
RowSeparator varchar 255      
TextQualifier varchar 255      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
ExtInfo varchar max      
FieldRef int 4      
FieldValue varchar 255      
FillCharacter varchar 1      
FillJustify tinyint 1   Fill Justify 0 = Left, 1 = Right
FillLength int 4      
Footer varchar 255      
Format varchar 255      
Header varchar 255      
Multiplier pDec 13      
SectionRef int 4      
SeqNum int 4      
ts timestamp 8      
Type tinyint 1   Type 0 = Text, 1 = Date, 2 = Number
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
Footer varchar 255      
GroupValue varchar 255      
Header varchar 255      
LayoutRef int 4      
SectionRef int 4      
SeqNum int 4      
ts timestamp 8      
Type tinyint 1   Type 0 = Header, 1 = Detail, 2 = Footer, 9 = Block
Column Name Column Type Length Default Value Description Enumeration
DefaultFileName varchar 255      
Description varchar 30      
DisplayFilter nvarchar max      
FieldSeparator varchar 255      
FileType tinyint 1   Import File Type 0 = Reserved, 1 = Delimited, 2 = Fixed Width, 3 = Reserved
Filter nvarchar max      
FunctionId varchar 10      
Id int 4      
LayoutId varchar 10      
RowSeparator varchar 255      
SkipRows int 4      
TextQualifier varchar 255      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 30      
ExtInfo varchar max      
FieldType smallint 2   Field Type 1 = Raw Text, 0 = Text, 1 = Number, 2 = Date
FieldValue varchar 255      
FieldWidth int 4      
Id int 4      
ImportLayoutId int 4      
SeqNum int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Consumer varchar max      
Description varchar 30      
FunctionId varchar 10      
Id int 4      
MapId varchar 10      
PropertyMap varchar max      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Program varchar 30      
Descr varchar 50      
InternetPath varchar 255      
Address1 varchar 30      
City varchar 30      
State varchar 30      
PostalCode varchar 30      
Additional1 varchar 50      
HoldingCharacters varchar 30      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AppID char 2      
MenuId int 4      
MenuType tinyint 1 0 Menu Type 0 = Company, 1 = Payroll, 2 = System
ParentId int 4 0    
Order smallint 2 0    
ReferenceId varchar 10      
ObjectType tinyint 1 -2 Object Type 2 = Form, 3 = Report, 6 = Comment, 7 = Function, 8 = Menu, 11 = Document, 12 = URL
Object varchar 255      
Param varchar 12      
HideYn bit 1 0    
Author varchar 20      
PluginName nvarchar 510      
AssemblyName nvarchar 510      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
AssemblyName nvarchar 510      
Description nvarchar 100      
MenuId int 4      
PluginName nvarchar 510      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
MenuId int 4      
LangID nchar 6      
Descr nvarchar 100      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id nvarchar 10      
Descr pDescription 255      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 6      
ScheduleId nvarchar 10      
Descr pDescription 255      
BeginDate datetime 8      
EndDate datetime 8      
DayValue tinyint 1   Day Value 1 = Sunday, 2 = Monday, 3 = Tuesday, 4 = Wednesday, 5 = Thursday, 6 = Friday, 7 = Saturday
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 6      
ParentId bigint 6      
ResourceType tinyint 1     0 = None, 1 = Customer, 2 = Vendor, 3 = Employee, 4 = Technician (default)
ResourceId nvarchar 255      
EventType tinyint 1     0 = Resource Unavailable, 1 = Resource Available
PatternType tinyint 1     0 = Normal, 1 = Recurring Pattern, 2 = Occurrence, 3 = Changed Occurrence, 4 = Deleted Occurrence
OccurrenceId int 4      
StartDate datetime 8      
StartTime int 4 0    
TimeZone smallint     +/- UTC offset in minutes for current time zone  
Duration int 4 0    
Subject nvarchar 255      
Description nvarchar max      
RecurType tinyint 1     0 = None, 1 = Daily, 2 = Weekly, 3 = Monthly, 4 = Yearly
RecurFrequency smallint     # of RecurType units between occurrences  
RecurInstance tinyint 1     0 = Specific, 1 = First, 2 = Second, 4 = Third, 8 = Fourth, 16 = Last
RecurDay tinyint 1   Day # of month, bitmasked days of week depending on instance type 1 = Sun, 2 = Mon, 4 = Tue, 8 = Wed, 16 = Thurs, 32 = Fri, 64 = Sat, 128 = Weekday, 256 = Weekend
RecurMonth tinyint     Month # of year when RecurType = Yearly, otherwise not applicable.  
RecurStart datetime 8      
RecurEnd datetime 8      
RecurCount int       <1 = Unused, >0 = # ends after # of recurrences
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 6      
ScheduleDateId bigint 6      
BeginTime int 4 0    
Duration int 4 0    
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RecordType char 1      
Title varchar 50      
Position smallint 2 0    
Length smallint 2 0    
Note varchar 50      
Column Name Column Type Length Default Value Description Enumeration
CompId pCompID 3      
Store varbinary max      
ts timestamp 8      
UserName pUserId 20      
UserPrefId int 4      
Column Name Column Type Length Default Value Description Enumeration
ColumnId int 4      
Criteria varchar 255      
Description varchar 255      
Flags int 4     1 = PK Column, 2 = Allow Nulls (nulls are valid values), 4 = Skip Change Id processing, 8 = Skip Validation processing, 16 = Skip Deletion processing, 1024 = Obsolete/Invalid column, 2048 = Future column
KeyColumnId int 4      
KeyGroup int 4      
Name varchar 255      
Notes text 16      
TableId int 4      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
DataSource varchar max      
DBId tinyint 1   Database ID 0 = Company, 1 = System, 2 = Current Payroll Year
Defaults varchar max      
Description nvarchar 200      
Enums nvarchar max     colname1:value1;text1;value2;text2;value3;text3|colname2:value1;text1;value2;text2
Formats nvarchar max     colname1:formattag1|colname2:formattag2
Id varchar 30      
KeyId varchar max      
ReplaceId varchar 30      
Volatile bit 1      
Column Name Column Type Length Default Value Description Enumeration
SeqNum int 4      
FormId nvarchar 100      
HostId pWrkStnID 20 '{all}'    
CopyText nvarchar 100      
PrintOrder tinyint 1 -1    
DeviceName nvarchar 510 n'{default}'    
Disabled bit 1 0    
Column Name Column Type Length Default Value Description Enumeration
FormId nvarchar 20      
Descr nvarchar 100      
DocumentDeliveryEnabled bit 1 0    
DeliveryEntityType tinyint 1 0    
AppId nchar 4      
AttachmentName nvarchar 60      
SchemaFileName nvarchar 255      
Column Name Column Type Length Default Value Description Enumeration
TypeID varchar 10      
DbId varchar 4   Database ID NNN = Company, SYS = SYS, PAYR = Payroll Year
TableName varchar 255      
ColumnName varchar 255      
DepOrder tinyint 1 0    
SkipYn bit 1 0    
Criteria varchar 255      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ApplicationId varchar 2      
DepOrder int 4 0    
Description varchar 255      
Flags int 4     1024 = Obsolete/Invalid table, 2048 = Future table
Location varchar 4      
Name varchar 255      
Notes text 16      
Scale int 4 0    
TableId int 4      
ts timestamp 8      
ValidateCriteria varchar 255      
Column Name Column Type Length Default Value Description Enumeration
ActivityId uniqueidentifier 16      
Description nvarchar max      
UpdDate datetime 8 getdate()    
UName nvarchar 256 suser_sname()    
WrkStnID nvarchar 256 host_name()    
Column Name Column Type Length Default Value Description Enumeration
HistID int 4      
VerInfo1 nnvarchar 100      
VerInfo2 nnvarchar 100      
UpdFile nvarchar 510      
UpdDate datetime 8 getdate()    
UName nnvarchar 510 suser_sname()    
WrkStnID pUserID 20 host_name()    
Column Name Column Type Length Default Value Description Enumeration
Available varchar max      
DataSource varchar max   Data Source Placeholders: {CF} = Custom Fields, {SYSDB} = System DB, {COMP} = Company DB, {PAYR} = Current Payroll Year DB
Defaults varchar max      
Description nvarchar 200      
Enums nvarchar max     colname1:value1;text1;value2;text2;value3;text3|colname2:value1;text1;value2;text2
FilterId varchar 30      
Formats nvarchar max     colname1:formattag1|colname2:formattag2
Id varchar 30      
ReplaceId varchar 30      

*tblWmPhysicalCountBatch -- WM Physical Count Batch table

*tblWmPhysicalCountBinList -- WM Physical Count Bin List table

*tblWmPhysicalCountHeader -- WM Physical Count Header table

*tblWmPhysicalCountDetail -- WM Physical Count Detail table

*tblWmPhysicalCountEntry -- WM Physical Count Entry table

*tblWmPhysicalCountCostVariance -- WM Physical Count Cost Variance table

*tblWMLocationZone -- WM Location Zone table